SELECT
    TABSCHEMA SCHEMA,
    TABNAME tablename,
    COLNAME columnname,
    COLNO index,
    TYPENAME type,
    LENGTH,
    SCALE,
    DEFAULT defaultvalue,
    case when NULLS='Y' then 1 else 0 end  nullable ,
    KEYSEQ isprimarykey ,
    REMARKS REMARK
FROM
    SYSCAT.COLUMNS
    where TABSCHEMA ='${scema}'  and TABNAME ='${tablename}'
    order by  colno